﻿CREATE TABLE [dbo].[DefinedEntityTemplates] (
    [TemplateGroupName]      NVARCHAR (100) NOT NULL,
    [EntityType]             NVARCHAR (50)  NOT NULL,
    [EntitySubType]          NVARCHAR (50)  NOT NULL,
    [TemplateCode]           NVARCHAR (MAX) NULL,
    [IncludeRelatedEntities] BIT            CONSTRAINT [DF_DefinedEntityTemplates_IncludeRelatedEntities] DEFAULT ((1)) NULL,
    CONSTRAINT [PK_DefinedEntityTemplates] PRIMARY KEY CLUSTERED ([TemplateGroupName] ASC, [EntityType] ASC, [EntitySubType] ASC)
);

